SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[spSuaNhapHang](@maNhapHang int, @ngayNhap datetime, @tongTien int, @maKho int, @maHTTToan int, @tinhTrang int, @maNCC int, @ngayThanhToan datetime)
As
Begin
	Update NhapHang
		Set
			NhayNhap = @ngayNhap,
			TongTien = @tongTien,
			MaKho = @maKho,
			MaHTThanhToan = @maHTTToan,
			TinhTrang = @tinhTrang,
			MaNCC = @maNCC,
			NgayThanhToan = @ngayThanhToan
		Where MaNhapHang = @maNhapHang
End